package com.fowo.api.model.ship.plans.sub;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fowo.api.common.excel.ImageConvert;
import com.fowo.api.common.validator.EnumsString;
import com.fowo.api.sys.entity.SysFile;
import java.util.List;
import javax.validation.constraints.*;
import lombok.Getter;
import lombok.Setter;

/** 发货计划单子表 导入导出辅助模型 */
@Getter
@Setter
public class ShipPlansSubExcelPo {

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "所属发货计划单")
  private String parentShipPlansCreateBatchNumber;

  @ExcelIgnore
  @ExcelProperty(value = "所属发货计划单")
  private Long parentShipPlans;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "计划编号")
  private String orderSn;

  @Size(max = 50, message = "图片长度不能超过20")
  @ExcelProperty(value = "图片", converter = ImageConvert.class)
  private List<SysFile> img;

  @Size(max = 50, message = "MSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "MSKU")
  private String msku;

  @Size(max = 50, message = "FNSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "FNSKU")
  private String fnsku;

  @Size(max = 50, message = "ASIN长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "ASIN")
  private String asin;

  @Size(max = 50, message = "父ASIN长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "父ASIN")
  private String parentasin;

  @Size(max = 50, message = "产品长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "产品")
  private String productIdName;

  @ExcelIgnore
  @ExcelProperty(value = "产品")
  private Long productId;

  @Size(max = 50, message = "SKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "SKU")
  private String sku;

  @Size(max = 50, message = "店铺长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "店铺")
  private String shopIdShopName;

  @ExcelIgnore
  @ExcelProperty(value = "店铺")
  private Long shopId;

  @NotNull(message = "计划发货量不能为空")
  @Size(max = 50, message = "计划发货量长度不能超过20")
  @ExcelProperty(value = "*计划发货量")
  private Long plannedShipment;

  @Size(max = 50, message = "总计发货量长度不能超过20")
  @ExcelProperty(value = "总计发货量")
  private Long totalShipment;

  @Size(max = 50, message = "差异量长度不能超过20")
  @ExcelProperty(value = "差异量")
  private Long differenceQuantity;

  @Size(max = 50, message = "运输方式长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "运输方式")
  private String typeOfShipping;

  @Size(max = 50, message = "物流商长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "物流商")
  private String logisticsBusinessIdName;

  @ExcelIgnore
  @ExcelProperty(value = "物流商")
  private Long logisticsBusinessId;

  @Size(max = 50, message = "物流渠道长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "物流渠道")
  private String logisticsChannelName;

  @ExcelIgnore
  @ExcelProperty(value = "物流渠道")
  private Long logisticsChannel;

  @Size(max = 50, message = "预计到货时间长度不能超过20")
  @DateTimeFormat("yyyy年MM月dd日")
  @ExcelProperty(value = "预计到货时间")
  private java.util.Date estimatedTimeOfArrival;

  @Size(max = 50, message = "发货仓库长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "发货仓库")
  private String deliveryWarehouseIdName;

  @ExcelIgnore
  @ExcelProperty(value = "发货仓库")
  private Long deliveryWarehouseId;

  @Size(max = 50, message = "包装类型长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "包装类型")
  private String packagingType;

  @Size(max = 50, message = "备注长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "备注")
  private String remarks;

  @EnumsString(
    value = { "待处理", "已处理" },
    message = "状态的可用值为 “待处理”, “已处理” 其中之一"
  )
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "状态")
  private String state;

  @Size(max = 50, message = "单箱数量（PCS）长度不能超过20")
  @ExcelProperty(value = "单箱数量（PCS）")
  private Integer perCarton;

  @Size(max = 50, message = "箱数长度不能超过20")
  @ExcelProperty(value = "箱数")
  private Integer cartonNumbers;

  @Size(max = 50, message = "发货时间长度不能超过20")
  @DateTimeFormat("yyyy年MM月dd日")
  @ExcelProperty(value = "发货时间")
  private java.util.Date scheduledDeliveryTime;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "是否锁定库存")
  private String isLock;

  @Size(max = 50, message = "包装规格长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "包装规格")
  private String specifications;

  @Size(max = 50, message = "箱规长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "箱规")
  private String boxgauge;

  @Size(max = 50, message = "CBM(m2)长度不能超过20")
  @ExcelProperty(value = "CBM(m2)")
  private java.math.BigDecimal cbm;

  @Size(max = 50, message = "体积重(kg)长度不能超过20")
  @ExcelProperty(value = "体积重(kg)")
  private java.math.BigDecimal volumeweight;

  @Size(max = 50, message = "单品净重(g)长度不能超过20")
  @ExcelProperty(value = "单品净重(g)")
  private java.math.BigDecimal itemweight;

  @Size(max = 50, message = "单品毛重(g)长度不能超过20")
  @ExcelProperty(value = "单品毛重(g)")
  private java.math.BigDecimal itemgrossweight;

  @Size(max = 50, message = "单箱重量(kg)长度不能超过20")
  @ExcelProperty(value = "单箱重量(kg)")
  private java.math.BigDecimal singleitemweight;

  @Size(max = 50, message = "单箱毛重长度不能超过20")
  @ExcelProperty(value = "单箱毛重")
  private java.math.BigDecimal singleboxweight;

  @Size(max = 50, message = "总净重长度不能超过20")
  @ExcelProperty(value = "总净重")
  private java.math.BigDecimal totalweight;

  @Size(max = 50, message = "fnskuname长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "fnskuname")
  private String fnskuname;

  @Size(max = 50, message = "标题长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "标题")
  private String title;
}
